package cn.gson.boot.model.pojos;

import javax.persistence.*;
import java.math.BigDecimal;
import java.sql.Timestamp;
import java.util.Objects;

@Entity
@Table(name = "guest", schema = "boot", catalog = "")
//获客表
public class Guest {
    private int gId;//获客id
    private User empId;//员工id
    private String gNeir;//采集内容
    private String gName;//表单名
    //采集内容
    private String gLianxir;//联系人
    private Long gLxfshi;//联系方式
    private String gGongsi;//公司
    private String gBeizhu;//备注
    private String gXuqiu;//需求

    private String gState;//处理状态（文字）
    private Integer gStates;//处理状态（数字）
    private String gHead;//所有者
    private String gFl;//分类
    private Timestamp gTjshij;//提交时间
    private BigDecimal gCben;//成本
    private String gRizhi;//日志
    private String gLaiy;//来源

    @Id
    @Column(name = "g_id", nullable = false)
    @GeneratedValue(strategy = GenerationType.IDENTITY,generator = "seq")
    public int getgId() {
        return gId;
    }

    public void setgId(int gId) {
        this.gId = gId;
    }

    //多个获客信息对应一个用户
    @ManyToOne
    @JoinColumn(name = "emp_id", nullable = true)
    public User getEmpId() {
        return empId;
    }

    public void setEmpId(User empId) {
        this.empId = empId;
    }

    @Basic
    @Column(name = "g_neir", nullable = true, length = 255)
    public String getgNeir() {
        return gNeir;
    }

    public void setgNeir(String gNeir) {
        this.gNeir = gNeir;
    }

    @Basic
    @Column(name = "g_name", nullable = true, length = 255)
    public String getgName() {
        return gName;
    }

    public void setgName(String gName) {
        this.gName = gName;
    }

    @Basic
    @Column(name = "g_state", nullable = true, length = 255)
    public String getgState() {
        return gState;
    }

    public void setgState(String gState) {
        this.gState = gState;
    }

    @Basic
    @Column(name = "g_head", nullable = true, length = 255)
    public String getgHead() {
        return gHead;
    }

    public void setgHead(String gHead) {
        this.gHead = gHead;
    }

    @Basic
    @Column(name = "g_fl", nullable = true, length = 255)
    public String getgFl() {
        return gFl;
    }

    public void setgFl(String gFl) {
        this.gFl = gFl;
    }

    @Basic
    @Column(name = "g_tjshij", nullable = false)
    public Timestamp getgTjshij() {
        return gTjshij;
    }

    public void setgTjshij(Timestamp gTjshij) {
        this.gTjshij = gTjshij;
    }

    @Basic
    @Column(name = "g_cben", nullable = true, precision = 2)
    public BigDecimal getgCben() {
        return gCben;
    }

    public void setgCben(BigDecimal gCben) {
        this.gCben = gCben;
    }

    @Basic
    @Column(name = "g_rizhi", nullable = true, length = 255)
    public String getgRizhi() {
        return gRizhi;
    }

    public void setgRizhi(String gRizhi) {
        this.gRizhi = gRizhi;
    }

    @Basic
    @Column(name = "g_laiy", nullable = true, length = 255)
    public String getgLaiy() {
        return gLaiy;
    }

    public void setgLaiy(String gLaiy) {
        this.gLaiy = gLaiy;
    }

    @Basic
    @Column(name = "g_lianxir", nullable = true, length = 255)
    public String getgLianxir() {
        return gLianxir;
    }

    public void setgLianxir(String gLianxir) {
        this.gLianxir = gLianxir;
    }

    @Basic
    @Column(name = "g_lxfshi", nullable = true)
    public Long getgLxfshi() {
        return gLxfshi;
    }

    public void setgLxfshi(Long gLxfshi) {
        this.gLxfshi = gLxfshi;
    }

    @Basic
    @Column(name = "g_gongsi", nullable = true, length = 255)
    public String getgGongsi() {
        return gGongsi;
    }

    public void setgGongsi(String gGongsi) {
        this.gGongsi = gGongsi;
    }

    @Basic
    @Column(name = "g_beizhu", nullable = true, length = 255)
    public String getgBeizhu() {
        return gBeizhu;
    }

    public void setgBeizhu(String gBeizhu) {
        this.gBeizhu = gBeizhu;
    }

    @Basic
    @Column(name = "g_xuqiu", nullable = true, length = 255)
    public String getgXuqiu() {
        return gXuqiu;
    }

    public void setgXuqiu(String gXuqiu) {
        this.gXuqiu = gXuqiu;
    }

    @Basic
    @Column(name = "g_states", nullable = true)
    public Integer getgStates() {
        return gStates;
    }

    public void setgStates(Integer gStates) {
        this.gStates = gStates;
    }
}
